<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateExaminesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('examines', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name')->comment('认证基地名称');
            $table->integer('category')->comment('认证基地分类');
            $table->string('sponsor_certificates_type')->comment('主办方证件类型');
            $table->string('sponsor_certificates_number')->comment('主办方证件号码');
            $table->string('sponsor_certificates_location')->comment('主办方证件所在地');
            $table->string('sponsor_name')->comment('主办方工商营业执照主办单位名称');
            $table->string('business_license')->comment('主办方营业执照');
            $table->string('base_licensing')->comment('主办方基地授牌');
            $table->string('person_in_charge_number')->comment('负责人证件号码');
            $table->bigInteger('person_in_charge_tel')->comment('负责人电话号码');
            $table->string('email')->comment('电子邮件');
            $table->integer('state')->default(0)->comment('默认为0时为待审核状态，为1时为审核成功状态');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('examines');
    }
}
